package com.java.al.string;

public class PringOutString {
	public static void main(String[] args) {
		String str = "select card1.area_id,card1.city_id, card1.card_type, free_card,cata1.type_name card_typeName" +
					" from tma_city2custcard card1,catalog cata1" +
//					" where card1.area_id = "+city2custcardco.getArea_id()+"" +
					" where card1.area_id = 42" +
//					" and card1.city_id = "+city2custcardco.getCity_id()+"" +
					" and card1.city_id = 31" +
					" and card1.card_type = cata1.type_id and cata1.catalog_id = 23			" +
					" union" +
					" select card2.area_id,card2.city_id,card2.card_type, card2.free_card,cata2.type_name card_typeName" +
					" from tma_city2custcard card2,catalog cata2" +
					" where card2.area_id = 42 and card2.city_id = -1" +
					" and card2.card_type = cata2.type_id and cata2.catalog_id = 23			" +
					" union" +
					" select card3.area_id,card3.city_id,card3.card_type, card3.free_card,cata3.type_name card_typeName" +
					" from tma_city2custcard card3,catalog cata3" +
					" where card3.area_id = -1 and card3.city_id = -1" +
					" and card3.card_type = cata3.type_id and cata3.catalog_id = 23			" +
					" order by area_id desc, city_id desc";
		System.out.println( str );
	}
}
